<%@ page import="java.sql.*,studentportal.*"%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65"><!--mstheme--><font face="Trebuchet MS, Arial, Helvetica">&nbsp;<!--mstheme--></font></td>
  </tr>
</table>
<%
					System.out.println("ss");
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					ResultSet rs=st.executeQuery("select * from student_master");
%>
<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="33%">
      <p align="center"><a href="CorporatesStudentsList.jsp">Student Information</a></td>
    <td width="33%">
      <p align="center"><a href="Notifications.jsp">Notifications</a></td>
    <td width="34%">
      <p align="center"><a href="Home.html">Home</a></td>
  </tr>
</table>
    
<br/><br/><br/><br/>
<table border="1" width="100%"  bordercolor="#0000FF">
	<tr>
		<th>Student ID</th>
		<th>Student Name</th>
		<th>Student Add</th>
		<th>Student DOB</th>
		<th>Student  Phone</th>
		<th>Student Email</th>
		<th>Student DOJ Date</th>
	</tr>
	<%
			while(rs.next())
			{
	%>
				<tr>
						<td><%=rs.getString(1)%></td>
						<td><%=rs.getString(2)%></td>
						<td><%=rs.getString(3)%></td>
						<td><%=rs.getDate(4)%></td>
						<td><%=rs.getString(5)%></td>
						<td><%=rs.getString(6)%></td>
						<td><%=rs.getDate(7)%></td>
				</tr>
	<%
			}
			//rs.close();
			st.close();
			con.close();
	%>

</table>
</body>

</html>
